Technology Integration Lesson Plan 
CONTENT AREA: Math 
TOPIC: Probability and Graphing 
GRADE LEVEL: 4
 TIME TO COMPLETE: Approx. 2-3 45 minute sessions 
TECHNOLOGY FOCUS/ 
APPLICATION TEKS:  1 A-C, 2 A-E, 7 A, 10 A-B, 11 A 
CONTENT AREA TEKS: 4.13 A-C 
CONTENT OBJECTIVES(S): 
1.	Students predict outcome of experiment. 
2.	Students record actual outcomes of experiment. 
3.	Students create bar graphs to represent data. 
4.	Students analyze graph information and write a paragraph explaining what happened. 
5.	Students create problems that can be solved with the graph information. 
6.	Students share their questions and solve each other’s problems. 

RESOURCES/MATERIALS: 
1.	Hot air Popcorn Popping machine 
2.	some un-popped kernels 
3.	Twister playing mat 
4.	Any sheet for collecting data 
5.	Excel 

LESSON PROCEDURE: 
1.	Teacher puts the popcorn machine in the middle of the Twister playing mat. 
2.	The students carefully count out 100-150 kernels of popping corn. 
3.	Students predict how many kernels will land on each color of the Twister board when popped. (Later the teacher will take the top off of the popcorn popper so that the popcorn will “fly” out the top and land on the mat.) 
4.	The students need to also predict how many kernels they think will not land on a color or will not land on the mat. 
5.	Students record predictions on a data sheet. 
6.	Teacher pops the corn on the Twister mat (without the lid on the popcorn popper). 
7.	Students carefully count how many kernels landed on each color (red, blue, yellow, green). 
8.	Students count how many did not land on a color and how many did not pop. 
9.	Record data on data sheet. 
10.	At the computer, students enter data into an Excel spreadsheet and create a double-bar graph showing their predictions and actual numbers for the activity. 
11.	Students analyze graph information and write a paragraph explaining what happened. 
12.	Students create problems that can be solved with the graph information. 
13.	Students share their questions and solve each other’s problems. 

Spreadsheet Preparation 
1.	Go to Start, programs, and click Microsoft Excel.  
2.	In cell A1, type the word color. Press Tab.  
3.	In cell B1, type the word Prediction. 
4.	In cell C1, type the word Actual. 
5.	In cell A2, type the word red. Press Enter. 
6.	In cell A3, type the word yellow. Press Enter. 
7.	In cell A4, type the word green. Press Enter. 
8.	In cell A5, type the word blue. Press Enter.  
9.	In cell A6, type the word other. Press Enter. 
10.	In cell A7, type the word Total. Press Enter. 

Counting and Recording Data 
1.	Predict the number of popped popcorn kernels that you think will land on each of the four colors. Record the data in column B. (B6 is where you type the total number of kernels that you predict won’t land on any of the four colors.) 
2.	After the popcorn has popped, count the popped corn and type the actual number of kernels that landed on all of the red colored circles in cell C2. 
3.	Count the ones that landed on yellow type the number in cell C3.  
4.	Count the rest and record your results in column C. Put the total number of kernels that either landed on the white area of the mat or off the mat in cell C6. 
5.	Highlight cells B2 to C6. Go to the toolbar and click the AutoSum button.

a.	The total number of popcorn kernels that popped should appear in the two columns.  
Formatting Chart 
1.	Highlight cells in your chart A1 to C7. Right click on top of the chart.  
2.	Click Format Cells from the pop-up menu. 
3.	Click the Font tab and change to Arial 14.  
4.	Click the border tab and apply a border. (Click on Outside and Inside buttons.) 

Applying Chart Wizard 
1.	With your chart data still highlighted, go to the toolbar and click the chart  wizard button. 
1.	There are four steps. Click Next for Step 1. 
2.	Step 1 shows all the different graphs. The column graph is highlighted. We will use it.  
3.	Click Next to go to Step 2. We will stick to these default settings.  
4.	Click Next to go to Step 3. Under the title tab type in a title such as Popping Colors or Twister Popcorn.  
5.	Type in the word Color for the category of axis x.  
6.	Type in the word Number for the value of axis y.  
7.	Click Next to go to step four.  Select the As New Sheet.  
8.	Click Finish. 
9.	Click on the Sheet 1 tab at the bottom to view your data.  

Formatting the Graph 
1.	Double click on the bar that represents Prediction to highlight all of that color of bar. 
2.	Click on Fill Effects.  
3.	Click on the Pattern tab.  
4.	Choose a pattern with stripes and click okay. 
5.	Click okay again.  
6.	Double click on the bar that represents Actual to highlight all of that color of bar. 
7.	Repeat steps 2 and 3. 
8.	Choose a pattern with dots in it. 
9.	Click okay and then okay again.  

Adding a Header or Footer 
1.	Click the magnifying class to go to Print Preview. 
2.	Click Setup. 
3.	Go to the Header/Footer tab. 
4.	Click Custom Header and add a title. Ex: Colorful Popcorn 
5.	Click OK and then select Custom Footer. 
6.	Type your name for the footer and then click OK.  Click close.  
7.	Save and print your graph. 

LISD technology/nash